iT邦幫忙

第 12 屆 iThome 鐵人賽

DAY 14
0
Modern Web

用30days 了解web系列 第 14

(day 14) Database normalization

  • 分享至 

  • xImage
  •  

NORMALIZATION is a database design technique that reduces data redundancy and eliminates undesirable characteristics like Insertion, Update and Deletion Anomalies. Normalization rules divides larger tables into smaller tables and links them using relationships. The purpose of Normalization in SQL is to eliminate redundant (repetitive) data and ensure data is stored logically.

1NF (First Normal Form) Rules

  1. Each table cell should contain a single value.
  2. Each record needs to be unique.

2NF (Second Normal Form) Rules

  1. Be in 1NF
  2. Single Column Primary Key

3NF (Third Normal Form) Rules

  1. Be in 2NF
  2. Has no transitive functional dependencies

https://ithelp.ithome.com.tw/upload/images/20200927/20129609OCLAA92NYu.png


上一篇
(day 13) Making commit and reset commit with git
下一篇
(Day 15) git branch!
系列文
用30days 了解web30
圖片
  直播研討會
圖片
{{ item.channelVendor }} {{ item.webinarstarted }} |
{{ formatDate(item.duration) }}
直播中

尚未有邦友留言

立即登入留言